Data Engineer I
Welcome!
We invite you to explore the award-winning culture, people, rewards and opportunities that make Comerica Bank so special. Make your next career choice a confident one.
Qualifications
Position Qualifications:
• Bachelor's Degree from an accredited university in Computer Science, Engineering or in a Technology related field OR equivalent through a combination of education and/or technology experience OR 12 years of technology experience
• 4 years of experience in Data Engineering, BI Engineering or related field in architecting and developing end-to-end scalable data applications and data pipelines
• 4 years of development experience in extracting, transforming/manipulating, and loading data sets of various sizes using Informatica IICS cloud or Snowflake and experience using CI/CD automation, Jenkins etc.
• 4 years of experience using programming languages Python and querying languages (SQL)
• 4 years of working knowledge of different databases (e.g., SQL NoSQL)
• 3 years of experience developing strong collaborative relationships with key partners in data engineering, business intelligence, software development, finance, modelling, and product teams
• 2 years of experience working with software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing
• 2 years of experience using AWS or Azure cloud technologies leveraging S3, Lambda, EC2 resources
Licenses/Certificates:
• Preferred, Informatica CDI or Snowflake SnowPro or Amazon Web Services (AWS) Certified Solutions Architect
Job Description
Data Engineer I
A Data Engineer I works alongside senior Data Engineers, Information Architects, Data Scientists, and other stakeholders to design and maintain small to moderate data models. The Data Engineer I is responsible for day-to-day monitoring and maintaining small to medium-scale databases that support web applications and other digital services. The Data Engineer I is responsible for supporting reports that provide accurate and timely data for internal and external clients. The incumbent will assist with advancing a data infrastructure that powers our ability to make timely and data-driven decision. This role requires an entry-level familiarity of data architecture and extraction manipulation of data sets of small to medium sizes.
Position Responsibilities:
Design and Methodology
• Perform day-to-day monitoring of critical business flows and take ownership of triaging incidents.
• Create and maintain data tables in data analysis tools (i.e., Informatica, Snowflake).
• Utilize data from multiple cloud sources and develop/maintain dashboards.
• Review existing code to ensure performance and reliability of data extraction and processing.
• Review data products for analytics and Data Scientist team members to improve their productivity.
• Update and optimize local and metadata models.
• Document and test small to moderate data systems that bring together data from disparate sources.
• Manage existing pipelines from a variety of sources (relational, XML, etc.)
• Review and maintain solutions to track data quality, stabilize data pipeline, etc. to ensure reliable operations.
• Test data processes including performance of through data validation and verification.
Technical Consulting
• Work with development teams to create conceptual data models and data flows.
• Review modifications of existing systems for cross-compatibility.
• Evaluate implemented data systems for variances, discrepancies, and efficiency.
• Participate in data quality initiatives and troubleshooting.
• Participate in sprint planning meetings as needed.
• Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions.
• Optimize support for ad-hod analysis across various data sources.
Planning Organizing
• Ensure best practices are followed across architecture, codebase, and configuration.
• Review and make recommendations for ongoing reporting and analysis processes, automating or simplifying self-service modeling and production support for customers.
• In collaboration with the senior level Data Engineers, contribute to the exploration and understanding of new tools and techniques for improvements to the data pipeline.
Risk Management
• Review and are familiar with automated processes for performance and fault tolerance.
• Review functional and technical designs to build familiarity of risk and any missing requirements.
• Review security measures to protect data from unauthorized access or misuse.
• In collaboration with senior level Data Engineers, design backup and recovery procedures to ensure data integrity is maintained.
Administration/Support
• Keeps management informed of status of on activities through accurate, timely, and appropriate reporting.
• Contribute to Data Governance, system documentation and sharing of data asset knowledge.
• Actively participates in committees representing the department and/or planning unit.
• Keeps abreast of leading-edge technologies in the Data Engineering space.
About Comerica
We know our employees are critical to our overall success and we are dedicated to investing in their future. One of the ways we do this is to offer a comprehensive Total Rewards package designed to recognize and reward individual performance, as well support health, well-being, development and security for our colleagues and their family. Total Rewards consists of cash compensation, development and flexible benefit programs designed to meet individual needs today and in the future. Your salary will be commensurate with your work experience and our programs are reviewed regularly to ensure each remain competitive. We are proud to offer benefits such as health and welfare programs, strong retirement benefits, and generous paid time off programs. You and your eligible family members, including domestic partners and their children, can participate in medical, dental, and vision benefits, 401(k) and pension, income protection benefits such as life insurance, AD D, and supplemental health programs to offset unexpected health care expenses. We also have a variety of time off programs for things like vacation, sick time, disability, and parental leave. Eligibility for some programs varies based on employment status and tenure.
Upon offer, Comerica conducts a comprehensive background and fingerprint check.
NMLS certification requirement: where applicable, a favorable background check screening, credit check, fingerprint check, and NMLS certification is required in accordance with the SAFE Act.
Comerica Incorporated (NYSE: CMA) is a financial services company headquartered in Dallas, Texas, and strategically aligned into three major business segments; the Commercial Bank, the Retail Bank, and Wealth Management. Comerica's colleagues focus on relationships, and helping people and businesses be successful. In addition to Texas, Comerica Bank locations can be found in Arizona, California, Florida and Michigan, with select businesses operating in several other states, as well as in Canada and Mexico.
Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.
